package org.jeecg.modules.phone.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.phone.entity.PhoneAccountTask;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.phone.entity.PhoneAccountTaskJoinTaskVo;

import java.util.List;

/**
 * @Description: 账号的任务
 * @Author: jeecg-boot
 * @Date:   2022-08-11
 * @Version: V1.0
 */
public interface PhoneAccountTaskMapper extends BaseMapper<PhoneAccountTask> {
    @Select("SELECT a.id,a.task_status ,t.task_name,t.task_type " +
            "from phone_account_task a \n" +
            "LEFT JOIN phone_task t on a.task_id=t.id " +
            "${ew.customSqlSegment}")
    List<PhoneAccountTaskJoinTaskVo> PhoneAccountTask_PhoneTask(@Param(Constants.WRAPPER) Wrapper<PhoneAccountTaskJoinTaskVo> queryWrapper);




}
